﻿create table dbo.ControlButtons (
   ControlId            nvarchar(10)         collate Chinese_PRC_CI_AS not null,
   ControlName          nvarchar(50)         collate Chinese_PRC_CI_AS null,
   ControlOrder         int                  null,
   ControlIcon          varbinary(250)       null,
   Remark               nvarchar(150)        null,
   CreateBy             nvarchar(10)         collate Chinese_PRC_CI_AS null,
   CreateOn             datetime             null constraint DF_ControlButtons_CreateOn default getdate(),
   ModifyBy             nvarchar(10)         collate Chinese_PRC_CI_AS null,
   ModifyOn             datetime             null,
   constraint PK_ControlButtons primary key (ControlId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '按钮ID',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ControlId'
go

execute sp_addextendedproperty 'MS_Description', 
   '按钮名称',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ControlName'
go

execute sp_addextendedproperty 'MS_Description', 
   '按钮排序',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ControlOrder'
go

execute sp_addextendedproperty 'MS_Description', 
   '按钮图标',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ControlIcon'
go

execute sp_addextendedproperty 'MS_Description', 
   '创建人',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'CreateBy'
go

execute sp_addextendedproperty 'MS_Description', 
   '创建时间',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'CreateOn'
go

execute sp_addextendedproperty 'MS_Description', 
   '更改人',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ModifyBy'
go

execute sp_addextendedproperty 'MS_Description', 
   '更改时间',
   'user', 'dbo', 'table', 'ControlButtons', 'column', 'ModifyOn'
go